Helpful Information
Home
Categories
Contact us
Category: CSV
PHP --> MySQL --> CSV -->
The titled was inspired by annother user...ANY WAY!
How do I dump all my data from mySQL using PHP to a CSV file?
for example (like you need one)
I have a table named Ezine, and it has 2 columns, Name, and Email
"Name", "Email"
"Jonathan", "biodegradabl@gmail.com"
"Fred", "yupthisoworks@hotmail.com"
SELECT x, y, z INTO OUTFILE 'some/file' (http://dev.mysql.com/doc/refman/5.0/en/select.html) is the SQL command you're after.
--Simon
privacy (GDPR)